﻿CREATE TABLE [dbo].[FeadbackLog] (
    [Id]           INT             IDENTITY (1, 1) NOT NULL,
    [OpenId]       NVARCHAR (50)   NULL,
    [AppId]        NVARCHAR (50)   NULL,
    [TimeStamp]    NVARCHAR (50)   NULL,
    [MsgType]      NVARCHAR (50)   NULL,
    [FeedBackId]   NVARCHAR (50)   NULL,
    [TransId]      NVARCHAR (50)   NULL,
    [Reason]       NVARCHAR (500)  NULL,
    [Solution]     NVARCHAR (500)  NULL,
    [ExtInfo]      NVARCHAR (500)  NULL,
    [AppSignature] NVARCHAR (50)   NULL,
    [SignMethod]   NVARCHAR (50)   NULL,
    [IsVerified]   INT             NULL,
    [RawData]      NVARCHAR (2000) NULL,
    [CreateDate]   DATETIME        NULL,
    [WXCreateDate] DATETIME        NULL,
    [Remark]       NVARCHAR (500)  NULL,
    PRIMARY KEY CLUSTERED ([Id] ASC)
);


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'支付该笔订单的用户 ID，商户可通过公众号其他接口为付款用户服务。', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'OpenId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'字段名称：公众号 id；字段来源：商户注册具有支付权限的公众号成功后即可获得；传入方式：由商户直接传入。', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'AppId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'字段名称：时间戳；字段来源：商户生成从 1970 年 1 月 1 日 00：00：00 至今的秒数，即当前的时间；由商户生成后传入。取值范围：32 字符以下', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'TimeStamp';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'通知类型  request  用户提交投诉  confirm  用户确认消除投诉  reject  用户拒绝消除投诉', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'MsgType';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'投诉单号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'FeedBackId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'交易订单号', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'TransId';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户投诉原因', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'Reason';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'用户希望解决方案', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'Solution';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'备注信息+电话', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'ExtInfo';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'依然是根据前文 paySign 所述的签名方式生成，参不签名的字段为： appid、', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'AppSignature';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'签名方式', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'SignMethod';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'是否验证通过', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'IsVerified';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'原生数据', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'RawData';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'创建时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'CreateDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'微信服务器创建时间', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'WXCreateDate';


GO
EXECUTE sp_addextendedproperty @name = N'MS_Description', @value = N'备注', @level0type = N'SCHEMA', @level0name = N'dbo', @level1type = N'TABLE', @level1name = N'FeadbackLog', @level2type = N'COLUMN', @level2name = N'Remark';

